﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DB_NH.DB_Model.ywxt
{
    /// <summary>
    /// 业务系统的用户信息
    /// </summary>
    [Serializable]
    public class t_sys_department
    {

        #region 数据表名称
        public static readonly string TableName = "t_sys_deptartment";
        #endregion

        #region 数据表字段结构
        public struct Columns
        {
            /// <summary>
            /// 部门id
            /// </summary>
            public static readonly string dept_id = @"dept_id";

            /// <summary>
            /// 部门名称
            /// </summary>
            public static readonly string dept_name = @"dept_name";

            /// <summary>
            /// 部门代码
            /// </summary>
            public static readonly string dept_code = @"dept_code";

            /// <summary>
            /// 部门联系电话
            /// </summary>
            public static readonly string user_truename_en = @"user_truename_en";

            /// <summary>
            /// 部门传真
            /// </summary>
            public static readonly string dept_fax = @"dept_fax";

            /// <summary>
            /// 部门联系人
            /// </summary>
            public static readonly string dept_linker = @"dept_linker";

            /// <summary>
            /// 部门联系联系邮箱
            /// </summary>
            public static readonly string dept_email = @"dept_email";

            /// <summary>
            /// 是否有效标志
            /// </summary>
            public static readonly string is_valid = @"is_valid";

            /// <summary>
            /// 创建时间
            /// </summary>
            public static readonly string create_date = @"create_date";
        }
        #endregion

        #region 字段
        /// <summary>
        /// 部门ID
        /// </summary>
        public virtual string dept_id { get; set; }

        /// <summary>
        /// 部门名称
        /// </summary>
        public virtual string dept_name { get; set; }

        /// <summary>
        /// 部门代码
        /// </summary>
        public virtual string dept_code { get; set; }

        /// <summary>
        /// 部门联系电话
        /// </summary>
        public virtual string dept_phone { get; set; }

        /// <summary>
        /// 部门传真
        /// </summary>
        public virtual string dept_fax { get; set; }

        /// <summary>
        /// 部门联系人
        /// </summary>
        public virtual string dept_linker { get; set; }

        /// <summary>
        /// 部门联系联系邮箱
        /// </summary>
        public virtual string dept_email { get; set; }

        /// <summary>
        /// 是否有效
        /// </summary>
        public virtual int is_valid { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public virtual DateTime create_date { get; set; }

        /// <summary>
        /// 部门员工
        /// </summary>
        public virtual IList<t_sys_user> users { get; set; }

        /// <summary>
        /// 部门费用
        /// </summary>
        public virtual IList<t_sys_department> dept_fys { get; set; }
        #endregion

        public t_sys_department()
        {
            users = new List<t_sys_user>();
            dept_fys = new List<t_sys_department>();
        }
    }
}
